2016-03-16 - 25730 - Spec - XPO Menlo Files name change #materialmaster #MMPPSupport

SPECIFICATIONS

25730 - Spec - XPO Menlo Files name change


Purpose

XPO/Menlo Files name change

Admin Info

Purpose
 XPO/Menlo Files name change
Requested By
 Bhumi
Spec Created By
 Adithya, Damodhier
Spec Created Date
 03/16/2016
Spec QA by
 Adithya, Damodhier
Objects
 ZRMM_MTL_CHGS_EXT
ZRMM_MTL_PLANT_EXT
Document Status
 Complete

Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
2
 Documentation
 08
3
 Development/ Config
 16
4
 Unit test in DEV
 12
5
 Unit test in QUA
6
 Other activity

TOTAL
 36
References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any





Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
When the MENLO jobs are processed the files are dropped in AL11, files are then picked up by GIS and renamed as per the requirement.
Those files are sent through GIS currently, will be switched to IBM for EDI process.
As it will be switched to IBM it takes long time to change the code in program (IBM end) for changing the name of the file.
Requirement is to change the file name by Menlo program so as it can generate the files with the specified Name then EDI can just pick up the file and send to Menlo

Discussion held on 03/15/2016
Rename the files as per below and drop them to the existing folder on AL11 (EDI/OUT).

For new Finished goods: "KEP832<Plantnumber>"_" <FILENUMBER>_EXT_FG_<YYYYMMDD_HHMMSS>".DAT
For new Raw material: "KEP832<Plantnumber>"_" <FILENUMBER>_EXT_RAW_<YYYYMMDD_HHMMSS>".DAT
For changes to Finished goods: "KEP832<Plantnumber>"_" <FILENUMBER>_CHG_FG_<YYYYMMDD_HHMMSS>".DAT
For changes to Raw materials: "KEP832<Plantnumber>"_" <FILENUMBER>_CHG_RAW_<YYYYMMDD_HHMMSS>".DAT

In Scope:

[List the activities to be included in scope]
Changed and Plant files.

Out of Scope:

[Out of scope activities]

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]
Change the programs "ZRMM_MTL_CHGS_EXT" and "ZRMM_MTL_PLANT_EXT"

For Program "ZRMM_MTL_CHGS_EXT"
When the program is processed the file Names shall be:
1. KEP832<PLANTNUMBER>_FILENUMBER_CHG_FG_YYYYMMDD_HHMMSS.DAT - for finished Material.
2. KEP832<PLANTNUMBER>_FILENUMBER_CHG_RAW_YYYYMMDD_HHMMSS.DAT - for Raw Material.

KEP832 is the hardcoded,
Plant is the Plant number of the material processed.
File number is the
CHG comes from the program change
FG comes form the input field "Material Type" maintained for the variant (eg; FERT - FG)
date and time stamps are generated with the date and time when the file is generated.

For Program "ZRMM_MTL_PLANT_EXT"
When the program is processed the file Names shall be:
1. KEP832<PLANTNUMBER>_FILENUMBER_EXT_FG_YYYYMMDD_HHMMSS.DAT - for finished Material.
2. KEP832<PLANTNUMBER>_FILENUMBER_EXT_RAW_YYYYMMDD_HHMMSS.DAT - for Raw Material.

KEP832 is the hardcoded,
Plant is the Plant number of the material processed.
File number is the
EXT comes from the program change
FG comes form the input field "Material Type" maintained for the variant (eg; FERT - FG)
date and time stamps are generated with the date and time when the file is generated.

The files shall be generated with .DAT



Test Plan

[List test scenarios/cases to be executed here]
Test ID
 Test Scenario
 Expected Results
MENLO1
 Create few FERT & RAW Materials and run the MENO extract program "ZRMM_MTL_PLANT_EXT"
 The MENLO file shall be extracted with file name
1. KEP832<PLANTNUMBER>_FILENUMBER_EXT_FG_YYYYMMDD_HHMMSS.DAT - for finished Material.
2. KEP832<PLANTNUMBER>_FILENUMBER_EXT_RAW_YYYYMMDD_HHMMSS.DAT - for Raw Material.
MENLO2
 Change few FERT & RAW Materials and run the MENLO extract program
"ZRMM_MTL_CHGS_EXT"
 The MENLO file shall be extracted with file name
1. KEP832<PLANTNUMBER>_FILENUMBER_CHG_FG_YYYYMMDD_HHMMSS.DAT - for finished Material.
2. KEP832<PLANTNUMBER>_FILENUMBER_CHG_RAW_YYYYMMDD_HHMMSS.DAT - for Raw Material.

Solution Details

[Provide complete technical details for configuration or programming here]
Modify the program:

Issues

[List Issues / Bugs identified in configuration or development]
XPO/Menlo Files name change